/**
 * Copyright 2005 The Apache Software Foundation
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */
package com.edi.db.type;

import java.sql.Date;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Types;
import java.util.Calendar;
import java.util.GregorianCalendar; 

import com.edi.db.EdiDb;
 

public class CalendarDateType extends NullableType {
	public void set(PreparedStatement st, Object value, int index) throws  SQLException {
		final Calendar cal = (Calendar) value;
		//st.setDate( index,  new Date( cal.getTimeInMillis() ), cal ); //JDK 1.5 only
		st.setDate( index,  new Date( cal.getTime().getTime() ), cal );
	}

	public int sqlType() {
		return Types.DATE;
	}

	public String toString(Object value) throws Exception {
		return  ( (Calendar) value ).getTime().toString() ;
	} 

	public boolean isEqual(Object x, Object y)  {
		if (x==y) return true;
		if (x==null || y==null) return false;

		Calendar calendar1 = (Calendar) x;
		Calendar calendar2 = (Calendar) y;

		return calendar1.get(Calendar.DAY_OF_MONTH) == calendar2.get(Calendar.DAY_OF_MONTH)
			&& calendar1.get(Calendar.MONTH) == calendar2.get(Calendar.MONTH)
			&& calendar1.get(Calendar.YEAR) == calendar2.get(Calendar.YEAR);
	}
	public String getName() {
		return "calendar_date";
	}
	public Object get(ResultSet rs, String name) throws  SQLException {

		Date date = rs.getDate(name);
		if (date!=null) {
			Calendar cal = new GregorianCalendar();
			cal.setTime(date);
			return cal;
		}
		else {
			return null;
		}

	}
	
	@Override
	public String getTypeValue(Object value) {
		// TODO Auto-generated method stub
		return String.valueOf(value);
	}



}
